﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_ALERTS_NOTIFICATION_TYPE_SE')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_ALERTS_NOTIFICATION_TYPE_SE
	END

GO

CREATE Procedure dbo.PRC_TB_ALERTS_NOTIFICATION_TYPE_SE
	(
		@TNT_ALERT_ID int
	)

AS

select
	TNT_TYPE
from TB_ALERTS_NOTIFICATION_TYPE
where TNT_ALERT_ID = @TNT_ALERT_ID


GO

GRANT EXEC ON dbo.PRC_TB_ALERTS_NOTIFICATION_TYPE_SE TO PUBLIC

GO